Essential Office 365: Second Edition (Computer Essentials) by Kevin Wilson

Author:Kevin Wilson [Wilson, Kevin]
Language: eng
Format: epub
Tags: Microsoft Office 365
Publisher: Elluminet Press
Published: 2017-05-31T07:00:00+00:00

VLookup

VLOOKUP searches for a value in the first column of a specified table, and returns a value from the specified adjacent column.

=VLOOKUP (value to look for,

table to retrieve value from,

column number with value to return,

true for exact/false for approx)

In the example VLOOKUP function demo.xlsx, we are going to apply a lookup function to calculate our shipping cost according to the shipping rates table (F15:G20).

To insert a VLOOKUP, click on the cell you want the calculation to appear in (D12), then go to your formulas ribbon and click ‘insert function’.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.